CREATE TABLE `dim_tab_fee_config_base` (
  `id` bigint(20) NULL COMMENT "主键ID",
  `fee_type` varchar(65533) NULL COMMENT "费用类型",
  `menu` varchar(65533) NULL COMMENT "使用菜单",
  `start_date` varchar(65533) NULL COMMENT "启用时间",
  `end_date` varchar(65533) NULL COMMENT "有效结束时间",
  `create_time` varchar(65533) NULL COMMENT "创建日期",
  `create_user` varchar(65533) NULL COMMENT "创建人",
  `update_time` varchar(65533) NULL COMMENT "更新时间",
  `update_user` varchar(65533) NULL COMMENT "更新人",
  `status` tinyint(4) NULL COMMENT "启用状态 0-禁用,1-启用",
  `ten_half_fix_fee` decimal64(10, 2) NULL COMMENT "10:30固定费用",
  `ten_half_target` varchar(65533) NULL COMMENT "10:30目标值(%)",
  `ten_half_one_fine` decimal64(10, 2) NULL COMMENT "10:30单票罚款金额",
  `ten_half_max_fine` decimal64(10, 2) NULL COMMENT "10:30最高罚款金额",
  `ten_half_min_fine` decimal64(10, 2) NULL COMMENT "10:30最低罚款票数",
  `eleven_half_fix_fee` decimal64(10, 2) NULL COMMENT "11:30固定费用",
  `eleven_half_target` varchar(65533) NULL COMMENT "11:30目标值(%)",
  `eleven_half_one_fine` decimal64(10, 2) NULL COMMENT "11:30单票罚款金额",
  `eleven_half_max_fine` decimal64(10, 2) NULL COMMENT "11:30最高罚款金额",
  `eleven_half_min_fine` decimal64(10, 2) NULL COMMENT "11:30最低罚款票数",
  `fourteen_fix_fee` decimal64(10, 2) NULL COMMENT "14:00固定费用",
  `fourteen_target` varchar(65533) NULL COMMENT "14:00目标值(%)",
  `fourteen_one_fine` decimal64(10, 2) NULL COMMENT "14:00单票罚款金额",
  `fourteen_max_fine` decimal64(10, 2) NULL COMMENT "14:00最高罚款金额",
  `fourteen_min_fine` decimal64(10, 2) NULL COMMENT "14:00最低罚款票数",
  `eighteen_fix_fee` decimal64(10, 2) NULL COMMENT "18:00固定费用",
  `eighteen_target` varchar(65533) NULL COMMENT "18:00目标值(%)",
  `eighteen_one_fine` decimal64(10, 2) NULL COMMENT "18:00单票罚款金额",
  `eighteen_max_fine` decimal64(10, 2) NULL COMMENT "18:00最高罚款金额",
  `eighteen_min_fine` decimal64(10, 2) NULL COMMENT "18:00最低罚款票数",
  `twenty_two_fix_fee` decimal64(10, 2) NULL COMMENT "22:00固定费用",
  `twenty_two_target` varchar(65533) NULL COMMENT "22:00目标值(%)",
  `twenty_two_one_fine` decimal64(10, 2) NULL COMMENT "22:00单票罚款金额",
  `twenty_two_max_fine` decimal64(10, 2) NULL COMMENT "22:00最高罚款金额",
  `twenty_two_min_fine` decimal64(10, 2) NULL COMMENT "22:00最低罚款票数"
) ENGINE=OLAP
UNIQUE KEY(`id`)
COMMENT "网点派件监控表"
DISTRIBUTED BY HASH(`id`) BUCKETS 3
PROPERTIES (
"replication_num" = "3",
"in_memory" = "true",
"storage_format" = "V2"
);